package com.example.demo.mapper;

import com.example.demo.entity.job.PrivateJob;
import com.example.demo.entity.major.MajorAll;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface MajorMapper {

    @Select("select depart_type,pro_type,pro_code,pro_name,degress_type from major;")
    List<MajorAll> lookAll();

    @Select("select depart_type from major group by depart_type;")
    List<String> departType();

    @Select("select avg(avg) as avg, avg(job0) as job0, avg(job1) as job1, avg(job2) as job2, avg(job3) as job3, avg(job4) as job4, avg(job5) as job5," +
            "avg(job6) as job6,avg(job7) as job7, avg(job8) as job8, avg(job9) as job9, avg(job10) as job10, avg(job11) as job11, avg(job12) as job12," +
            "avg(job13) as job13, avg(job14) as job14, avg(job15) as job15, avg(job16) as job16, avg(job17) as job17 from cityJobSalary ;")
    List<PrivateJob> getPrivate();
}
